POB Column Mappings Registry entry

Specifies a mapping between one or more tags (child, mother, father, deceased) which can be referenced in a Letter template, to various pieces of information about the subject's place of birth stored in any (appropriate) module.

When designing a Letter template it is possible to specify various tags to extract and display details in a letter about the place of birth of the:

  • child
  • mother
  • father
  • deceased

The POB Order Columns Registry entry is a System setting which maps one or more tags (child, mother and / or father) to a column in the eorders table (Orders module) which holds details of the child, mother or father's place of birth (not the deceased's place of birth however).

With the POB Column Mappings Registry entry on the other hand, it is possible to map one or more tags (child, mother, father and / or deceased) to various pieces of information about the subject's place of birth stored in any (appropriate) module. Information could include, for example:

  • City of birth
  • PPP of birth (for Canadian Vital Records Offices, this is the Province Code)
  • Country of birth

Usage

This Registry entry is assigned to groups:

KeyGroup
Key 1Group
Key 2Default
Key 3Table
Key 4table
Key 5POB Column Mappings
Valuetag=col1:col2:col3;tag=col1:col2:col3;...
GroupDefaultTabletablePOB Column Mappingstag=col1:col2:col3; tag=col1:col2:col3;...

where:

tag=col1:col2:col3;tag=col1:col2:col3;...

is a semicolon separated list of mappings between a tag and various columns in table holding details about tag's place of birth, where:

tag

is any of:

  • child
  • mother
  • father
  • deceased

col

is a column in table holding place of birth details about tag. There can be one or more cols mapped to each tag.

Example

In this example, the child, mother and father tags are mapped to various column in the Births module:

KeySetting
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 ebirths
Key 5 POB Column Mappings
Value child=ChildCityTownOfBirth;father=FatherPOBCityTown:FatherPlaceOfBirthPPP:FatherPOBCountry; mother=MotherPOBCityTown:MotherPlaceOfBirthPPP:MotherPOBCountry